Revisiting an old friend as some date format junk was needing adjustment and leading 0s from txt file were being dropped. Script originally brought txt into xlsx and all data was “General” format. Tweak noted below brought all data into xlsx as “Text” format. Changed: $query.TextFileColumnDataTypes = ,1 * $worksheet.Cells.Columns.Count to $query.TextFileColumnDataTypes = ,2 * … Continue reading Convert CSV to XLSX via PowerShell